Dataset source: Kaggle (https://www.kaggle.com/worldbank/world-development-indicators?select=database.sqlite)
| CountryCode | ShortName | TableName | LongName | Alpha2Code | CurrencyUnit | SpecialNotes | Region | IncomeGroup | Wb2Code | ... | GovernmentAccountingConcept | ImfDataDisseminationStandard | LatestPopulationCensus | LatestHouseholdSurvey | SourceOfMostRecentIncomeAndExpenditureData | VitalRegistrationComplete | LatestAgriculturalCensus | LatestIndustrialData | LatestTradeData | LatestWaterWithdrawalData | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AFG | Afghanistan | Afghanistan | Islamic State of Afghanistan | AF | Afghan afghani | Fiscal year end: March 20; reporting period fo... | South Asia | Low income | AF | ... | Consolidated central government | General Data Dissemination System (GDDS) | 1979 | Multiple Indicator Cluster Survey (MICS), 2010/11 | Integrated household survey (IHS), 2008 | NaN | 2013/14 | NaN | 2013.0 | 2000.0 |
| 1 | ALB | Albania | Albania | Republic of Albania | AL | Albanian lek | NaN | Europe & Central Asia | Upper middle income | AL | ... | Budgetary central government | General Data Dissemination System (GDDS) | 2011 | Demographic and Health Survey (DHS), 2008/09 | Living Standards Measurement Study Survey (LSM... | Yes | 2012 | 2011.0 | 2013.0 | 2006.0 |
| 2 | DZA | Algeria | Algeria | People's Democratic Republic of Algeria | DZ | Algerian dinar | NaN | Middle East & North Africa | Upper middle income | DZ | ... | Budgetary central government | General Data Dissemination System (GDDS) | 2008 | Multiple Indicator Cluster Survey (MICS), 2012 | Integrated household survey (IHS), 1995 | NaN | NaN | 2010.0 | 2013.0 | 2001.0 |
| 3 | ASM | American Samoa | American Samoa | American Samoa | AS | U.S. dollar | NaN | East Asia & Pacific | Upper middle income | AS | ... | NaN | NaN | 2010 | NaN | NaN | Yes | 2007 | NaN | NaN | NaN |
| 4 | ADO | Andorra | Andorra | Principality of Andorra | AD | Euro | NaN | Europe & Central Asia | High income: nonOECD | AD | ... | NaN | NaN | 2011. Population data compiled from administra... | NaN | NaN | Yes | NaN | NaN | 2006.0 | NaN |
5 rows × 31 columns
| CountryName | CountryCode | IndicatorName | IndicatorCode | Year | Value | |
|---|---|---|---|---|---|---|
| 0 | Arab World | ARB | Adolescent fertility rate (births per 1,000 wo... | SP.ADO.TFRT | 1960 | 1.335609e+02 |
| 1 | Arab World | ARB | Age dependency ratio (% of working-age populat... | SP.POP.DPND | 1960 | 8.779760e+01 |
| 2 | Arab World | ARB | Age dependency ratio, old (% of working-age po... | SP.POP.DPND.OL | 1960 | 6.634579e+00 |
| 3 | Arab World | ARB | Age dependency ratio, young (% of working-age ... | SP.POP.DPND.YG | 1960 | 8.102333e+01 |
| 4 | Arab World | ARB | Arms exports (SIPRI trend indicator values) | MS.MIL.XPRT.KD | 1960 | 3.000000e+06 |
| SeriesCode | Topic | IndicatorName | ShortDefinition | LongDefinition | UnitOfMeasure | Periodicity | BasePeriod | OtherNotes | AggregationMethod | LimitationsAndExceptions | NotesFromOriginalSource | GeneralComments | Source | StatisticalConceptAndMethodology | DevelopmentRelevance | RelatedSourceLinks | OtherWebLinks | RelatedIndicators | LicenseType | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BN.KLT.DINV.CD | Economic Policy & Debt: Balance of payments: C... | Foreign direct investment, net (BoP, current US$) | NaN | Foreign direct investment are the net inflows ... | NaN | Annual | NaN | NaN | NaN | NaN | NaN | Note: Data are based on the sixth edition of t... | International Monetary Fund, Balance of Paymen... | NaN | NaN | NaN | NaN | NaN | Open |
| 1 | BX.KLT.DINV.WD.GD.ZS | Economic Policy & Debt: Balance of payments: C... | Foreign direct investment, net inflows (% of GDP) | NaN | Foreign direct investment are the net inflows ... | NaN | Annual | NaN | NaN | Weighted average | FDI data do not give a complete picture of int... | NaN | Note: Data starting from 2005 are based on the... | International Monetary Fund, International Fin... | Data on equity flows are based on balance of p... | Private financial flows - equity and debt - ac... | NaN | NaN | NaN | Open |
| 2 | BX.KLT.DINV.CD.WD | Economic Policy & Debt: Balance of payments: C... | Foreign direct investment, net inflows (BoP, c... | NaN | Foreign direct investment refers to direct inv... | NaN | Annual | NaN | NaN | Sum | FDI data do not give a complete picture of int... | NaN | Note: Data starting from 2005 are based on the... | International Monetary Fund, Balance of Paymen... | Data on equity flows are based on balance of p... | Private financial flows - equity and debt - ac... | NaN | NaN | NaN | Open |
| 3 | BM.KLT.DINV.GD.ZS | Economic Policy & Debt: Balance of payments: C... | Foreign direct investment, net outflows (% of ... | NaN | Foreign direct investment are the net inflows ... | NaN | Annual | NaN | NaN | Weighted average | NaN | NaN | Note: Data are based on the sixth edition of t... | International Monetary Fund, International Fin... | NaN | NaN | NaN | NaN | NaN | Open |
| 4 | BN.TRF.KOGT.CD | Economic Policy & Debt: Balance of payments: C... | Net capital account (BoP, current US$) | NaN | Net capital account records acquisitions and d... | NaN | Annual | NaN | NaN | NaN | NaN | NaN | Note: Data are based on the sixth edition of t... | International Monetary Fund, Balance of Paymen... | NaN | NaN | NaN | NaN | NaN | Open |
91
array(['Economic Policy & Debt: Balance of payments: Capital & financial account',
'Economic Policy & Debt: Balance of payments: Current account: Balances',
'Economic Policy & Debt: Balance of payments: Current account: Goods, services & income',
'Economic Policy & Debt: Balance of payments: Current account: Transfers',
'Economic Policy & Debt: Balance of payments: Reserves & other items',
'Economic Policy & Debt: External debt: Amortization',
'Economic Policy & Debt: External debt: Arrears, reschedulings, etc.',
'Economic Policy & Debt: External debt: Commitments',
'Economic Policy & Debt: External debt: Currency composition',
'Economic Policy & Debt: External debt: Debt outstanding',
'Economic Policy & Debt: External debt: Debt ratios & other items',
'Economic Policy & Debt: External debt: Debt service',
'Economic Policy & Debt: External debt: Disbursements',
'Economic Policy & Debt: External debt: Interest',
'Economic Policy & Debt: External debt: Net flows',
'Economic Policy & Debt: External debt: Net transfers',
'Economic Policy & Debt: External debt: Terms',
'Economic Policy & Debt: External debt: Undisbursed debt',
'Economic Policy & Debt: National accounts: Adjusted savings & income',
'Economic Policy & Debt: National accounts: Atlas GNI & GNI per capita',
'Economic Policy & Debt: National accounts: Growth rates',
'Economic Policy & Debt: National accounts: Growth rates:',
'Economic Policy & Debt: National accounts: Local currency at constant prices: Aggregate indicators',
'Economic Policy & Debt: National accounts: Local currency at constant prices: Expenditure on GDP',
'Economic Policy & Debt: National accounts: Local currency at constant prices: Other items',
'Economic Policy & Debt: National accounts: Local currency at constant prices: Value added',
'Economic Policy & Debt: National accounts: Local currency at current prices: Aggregate indicators',
'Economic Policy & Debt: National accounts: Local currency at current prices: Expenditure on GDP',
'Economic Policy & Debt: National accounts: Local currency at current prices: Value added',
'Economic Policy & Debt: National accounts: Shares of GDP & other',
'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Aggregate indicators',
'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Expenditure on GDP',
'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Value added',
'Economic Policy & Debt: National accounts: US$ at current prices: Aggregate indicators',
'Economic Policy & Debt: National accounts: US$ at current prices: Expenditure on GDP',
'Economic Policy & Debt: National accounts: US$ at current prices: Other items',
'Economic Policy & Debt: National accounts: US$ at current prices: Value added',
'Economic Policy & Debt: Official development assistance',
'Economic Policy & Debt: Purchasing power parity',
'Education: Efficiency', 'Education: Inputs',
'Education: Outcomes', 'Education: Participation',
'Environment: Agricultural production',
'Environment: Biodiversity & protected areas',
'Environment: Density & urbanization', 'Environment: Emissions',
'Environment: Energy production & use', 'Environment: Freshwater',
'Environment: Land use',
'Environment: Natural resources contribution to GDP',
'Financial Sector: Access', 'Financial Sector: Assets',
'Financial Sector: Capital markets',
'Financial Sector: Exchange rates & prices',
'Financial Sector: Interest rates',
'Financial Sector: Monetary holdings (liabilities)',
'Health: Disease prevention', 'Health: Health services',
'Health: Mortality', 'Health: Nutrition',
'Health: Population: Dynamics', 'Health: Population: Structure',
'Health: Reproductive health', 'Health: Risk factors',
'Infrastructure: Communications', 'Infrastructure: Technology',
'Infrastructure: Transportation', 'Poverty: Income distribution',
'Poverty: Poverty rates', 'Poverty: Shared prosperity',
'Private Sector & Trade: Business environment',
'Private Sector & Trade: Exports',
'Private Sector & Trade: Imports',
'Private Sector & Trade: Private infrastructure investment',
'Private Sector & Trade: Tariffs',
'Private Sector & Trade: Total merchandise trade',
'Private Sector & Trade: Trade facilitation',
'Private Sector & Trade: Trade indexes',
'Private Sector & Trade: Travel & tourism',
'Public Sector: Conflict & fragility',
'Public Sector: Defense & arms trade',
'Public Sector: Government finance: Deficit & financing',
'Public Sector: Government finance: Expense',
'Public Sector: Government finance: Revenue',
'Public Sector: Policy & institutions',
'Social Protection & Labor: Economic activity',
'Social Protection & Labor: Labor force structure',
'Social Protection & Labor: Migration',
'Social Protection & Labor: Performance',
'Social Protection & Labor: Unemployment'], dtype=object)
1344
| SeriesCode | Topic | IndicatorName | ShortDefinition | LongDefinition | UnitOfMeasure | Periodicity | BasePeriod | OtherNotes | AggregationMethod | LimitationsAndExceptions | NotesFromOriginalSource | GeneralComments | Source | StatisticalConceptAndMethodology | DevelopmentRelevance | RelatedSourceLinks | OtherWebLinks | RelatedIndicators | LicenseType | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1318 | SL.UEM.LTRM.ZS | Social Protection & Labor: Unemployment | Long-term unemployment (% of total unemployment) | NaN | Long-term unemployment refers to the number of... | NaN | Annual | NaN | NaN | Weighted average | Data on long-term unemployment are often colle... | NaN | Relevance to gender indicator: Even though, in... | International Labour Organization, Key Indicat... | The standard definition of long-term unemploym... | While short periods of joblessness are of less... | NaN | NaN | NaN | Open |
| 1319 | SL.UEM.LTRM.FE.ZS | Social Protection & Labor: Unemployment | Long-term unemployment, female (% of female un... | NaN | Long-term unemployment refers to the number of... | NaN | Annual | NaN | NaN | Weighted average | Data on long-term unemployment are often colle... | NaN | Relevance to gender indicator: Even though, in... | International Labour Organization, Key Indicat... | The standard definition of long-term unemploym... | While short periods of joblessness are of less... | NaN | NaN | NaN | Open |
| 1320 | SL.UEM.LTRM.MA.ZS | Social Protection & Labor: Unemployment | Long-term unemployment, male (% of male unempl... | NaN | Long-term unemployment refers to the number of... | NaN | Annual | NaN | NaN | Weighted average | Data on long-term unemployment are often colle... | NaN | Relevance to gender indicator: Even though, in... | International Labour Organization, Key Indicat... | The standard definition of long-term unemploym... | While short periods of joblessness are of less... | NaN | NaN | NaN | Open |
| 1321 | SL.UEM.NEET.FE.ZS | Social Protection & Labor: Unemployment | Share of youth not in education, employment or... | NaN | Share of youth not in education, employment or... | NaN | Annual | NaN | NaN | Weighted average | Data should be used cautiously because of diff... | NaN | When NEET rates are available for more than tw... | International Labour Organization, Key Indicat... | The standard definition of unemployed persons ... | Unemployment and total employment are the broa... | NaN | NaN | NaN | Open |
| 1322 | SL.UEM.NEET.MA.ZS | Social Protection & Labor: Unemployment | Share of youth not in education, employment or... | NaN | Share of youth not in education, employment or... | NaN | Annual | NaN | NaN | Weighted average | Data should be used cautiously because of diff... | NaN | When NEET rates are available for more than tw... | International Labour Organization, Key Indicat... | The standard definition of unemployed persons ... | Unemployment and total employment are the broa... | NaN | NaN | NaN | Open |
239
| Year | Value | |
|---|---|---|
| count | 56035.000000 | 56035.000000 |
| mean | 2001.769448 | 22.322251 |
| std | 7.838904 | 17.162863 |
| min | 1980.000000 | 0.000000 |
| 25% | 1996.000000 | 9.400000 |
| 50% | 2002.000000 | 17.200001 |
| 75% | 2008.000000 | 31.400000 |
| max | 2014.000000 | 96.699997 |
<class 'pandas.core.frame.DataFrame'> Int64Index: 4020 entries, 1032968 to 5637550 Data columns (total 6 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 CountryName 4020 non-null object 1 CountryCode 4020 non-null object 2 IndicatorName 4020 non-null object 3 IndicatorCode 4020 non-null object 4 Year 4020 non-null int64 5 Value 4020 non-null float64 dtypes: float64(1), int64(1), object(4) memory usage: 219.8+ KB
21
array(['Long-term unemployment (% of total unemployment)',
'Long-term unemployment, female (% of female unemployment)',
'Long-term unemployment, male (% of male unemployment)',
'Unemployment with primary education (% of total unemployment)',
'Unemployment with primary education, female (% of female unemployment)',
'Unemployment with primary education, male (% of male unemployment)',
'Unemployment with secondary education (% of total unemployment)',
'Unemployment with secondary education, female (% of female unemployment)',
'Unemployment with secondary education, male (% of male unemployment)',
'Unemployment with tertiary education (% of total unemployment)',
'Unemployment with tertiary education, female (% of female unemployment)',
'Unemployment with tertiary education, male (% of male unemployment)',
'Unemployment, female (% of female labor force) (national estimate)',
'Unemployment, male (% of male labor force) (national estimate)',
'Unemployment, total (% of total labor force) (national estimate)',
'Unemployment, youth female (% of female labor force ages 15-24) (national estimate)',
'Unemployment, youth male (% of male labor force ages 15-24) (national estimate)',
'Unemployment, youth total (% of total labor force ages 15-24) (national estimate)',
'Unemployment, youth female (% of female labor force ages 15-24) (modeled ILO estimate)',
'Unemployment, youth male (% of male labor force ages 15-24) (modeled ILO estimate)',
'Unemployment, youth total (% of total labor force ages 15-24) (modeled ILO estimate)'],
dtype=object)
Text(0.5, 1.0, 'Unemployment in G7 Countries - 1980 to 2014')
| CountryName | CountryCode | IndicatorName | IndicatorCode | Year | Value | |
|---|---|---|---|---|---|---|
| 1054337 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1980 | 17.000000 |
| 1137476 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1981 | 17.700001 |
| 1222204 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1982 | 19.200001 |
| 1307476 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1983 | 8.600000 |
| 1393052 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1984 | 9.400000 |
| 1479610 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1985 | 9.400000 |
| 1567354 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1986 | 10.600000 |
| 1656137 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1987 | 10.700000 |
| 1745295 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1988 | 11.000000 |
| 1836491 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1989 | 11.000000 |
| 1941656 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1990 | 9.800000 |
| 2058632 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1991 | 10.100000 |
| 2176839 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1992 | 9.300000 |
| 2299889 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1993 | 10.200000 |
| 2424658 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1994 | 11.100000 |
| 2554837 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1995 | 11.700000 |
| 2689960 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1996 | 11.900000 |
| 2825340 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1997 | 12.000000 |
| 2962240 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1998 | 12.100000 |
| 3101812 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 1999 | 11.700000 |
| 3250589 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2000 | 10.800000 |
| 3402710 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2001 | 9.600000 |
| 3555396 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2002 | 9.200000 |
| 3709646 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2003 | 8.900000 |
| 3865278 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2004 | 7.900000 |
| 4035371 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2005 | 7.700000 |
| 4213714 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2006 | 6.800000 |
| 4392669 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2007 | 6.100000 |
| 4572903 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2008 | 6.700000 |
| 4751946 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2009 | 7.700000 |
| 4934984 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2010 | 8.400000 |
| 5116392 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2011 | 8.400000 |
| 5291971 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2012 | 10.700000 |
| 5457559 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2013 | 12.100000 |
| 5588570 | Italy | ITA | Unemployment, total (% of total labor force) (... | SL.UEM.TOTL.NE.ZS | 2014 | 12.700000 |
Found: ecCodes v2.22.1. Your system is ready.
[NbConvertApp] Converting notebook World_Population.ipynb to html [NbConvertApp] Writing 9652383 bytes to World_Population.html
[NbConvertApp] Converting notebook World_Population.ipynb to html [NbConvertApp] Writing 14419929 bytes to World_Population.html